Subsidy amount calculation
This function enables the user to submit the process of all calculations linked to subsidies. For a given investment project, the following calculations are carried out:
- amount of the performed investment from the set of expenses allocated to this project,
- amount of the subsidies assigned to the project when they are proportional to the performed investment,
- amount of the investment capitalized only from expenses linked to accounting assets.
The result of these calculations is displayed in the Subsidies management function.
This processing is also used:
- for the investment project: to distribute the subsidy or the sum of the granted subsidies, on each subsidized expense posted for this project,
- to determine the depreciation basis for each financial asset linked to the subsidized expenses, on the subsidy plan (this basis corresponds to the sum of the granted subsidies linked to the asset).
- to determine the amount of subsidy reintegration based on the charges calculated in the depreciation plan for each asset linked to the investment project.
the Subsidy calculation process can be launched as many times as necessary to update the subsidies assigned to the project, if their status isIn process.
Prerequisite
Refer to documentation Implementation
Screen management
Entry screen
Presentation
This function is composed of a single screen that make it possible to:
- Either select the company to which the processing applies, and choose an investment project in the list of projects linked to this company.
The grid displays the list of companies for which investment projects have be recorded.
Selecting a company is done by checking the Calculate box on the line that corresponds to this company. This processing is a single company one, so only one company can be selected.
- Or to directly select the investment project to be taken into account in the processing, in which case the company in which the project is recorded is automatically selected.
- To specify the processing options: simulation, printing of a detailed log file. By default, the subsidy calculation process is simulated. No modification is recorded in the database.
- To launch the subsidy calculation process.
The result of the processing can be viewed in the log file displayed at processing completion. For each investment project, the following is displayed:
- the list of assigned subsidies
- the amount of performed investment
- the amount of capitalized investment
- the list of expenses allocated to the investment project, their amount and the assigned subsidy amount.
Close
Fields
The following fields are present on this tab :
Grid Companies
| The process is single-company and single-project. |
| This field displays the company code. |
Criteria
| This field is used to specify the reference for the investment project for which the subsidy calculation process should be carried out. |
| This check box is selected by default and runs the closing in simulation mode. In this case, controls and the process are carried out but there are no updates recorded in the database. Clear this check box to run in actual mode. In this case, you cannot reverse the closing and updates are recorded in the database. If you are using intermediate commits, it is recommended that the NIVTRACE – Log file level parameter (AAS chapter, MIS group) value is 0. |
| A log file is automatically displayed on process completion, showing the processing parameters. A Statistics section gives the number of selected assets, the number of assets updated as well as the number of assets not processed due to an error. Assets with errors are listed with their error reason. The viewing and printing of log files are possible at any time via the report code ATRACE - Print log file print request, obtained from the Supervisor function in the Print/Group print menu. |
Close
Processing description
For each investment project, the subsidy calculation process consists of the following steps:
- Calculation of the investmentcarried out: sum of the amounts Ex. tax converted in the company currency, of all the expenses posted on the investment project, whether subsidized or not.
- Calculation of the capitalizedinvestment: sum of the amounts Ex. tax converted in the company currency, of the sole expenses (whether subsidized or not) posted on the investment project and linked to financial assets.
- Calculation of the subsidies amount, in case the amount is proportional to the performed investment amount:
Amount of the performed investment X Percentage recorded for the subsidy with application of the threshold value recorded on the subsidy when it is of the Capped percentage type.
Note: after the fiscal year closing of the AccountingandFiscal contexts (and of the Subsidy plan), the two following calculations depend on the possibility to authorize or not the Review earlier subsidies process (GRTPRVUPD parameter - AAS chapter, GRT group) and therefore on the presence or absence of expenses for which the subsidy amount is fixed (forcing flag enabled).
- Distribution of the subsidies sum on the subsidized expenses:
- If the forcing flag of the subsidy amount is not activate on any expense, the distribution will be carried out according to the following rule:
Sum of the granted subsidy amounts X Converted expense amount Ex. tax / Converted amounts sum of the subsidized expenses Ex. tax.
- If the forcing flag of the subsidy amount is disabled for some expenses, the subsidy amount assigned to these expenses is fixed; the distribution is performed only on those for which the forcing flag is disabled according to the following rule:
Subsidy remainder to assign X Converted expense amount Ex. tax / Converted amounts sum of the subsidized expenses Ex. tax for which the forcing flag is disabled.
Note: the subsidy amount of the expenditures linked to an issued asset, in the current fiscal year or a previous fiscal year, is never updated: the forcing flag of this amount is automatically activated during the issuing process.
- Determination of the depreciation basis of the subsidy plan for each asset linked to the expenditures.
This depreciation basis equals the total of subsidy amounts of expenses attached to the asset.
Notes:
1/ The depreciation basis in the subsidy plan, of a non-issued asset, can be updated if the closing of the Accounting and Fiscal contexts is not completed and, after closing, only if the review of the earlier subsidies is authorized (GRTPRVUPD parameter - AAS chapter, GRT group set to 'Yes').
2/ The update of the depreciation base of closed assets, in the subsidy plan, corresponds to a method change associated with an adjustment of the depreciation variance. The conditions of this adjustment depend on the strategy defined at the level of the GRTDVEREG - Variance adjustment strategy parameter (AAS chapter, GRT group).
s3/ The depreciation basis for an issued asset is never updated: the forcing flag for the subsidy amount of the expenditures to which it is linked, is automatically activated during the issuing process. - Calculation of the subsidy plan depreciations.
- Calculation of the fiscal year subsidy reintegration amount. This calculation is based on the charges calculated in the subsidy depreciation plan for each asset linked to the investment project and consists of:
Total of FY depreciation charges of the subsidy plan, of the assets allocated to the investment project X Subsidy amount / Total of subsidy amounts assigned to the investment project.
- Generation of a subsidy re-integration event GRTCRB.
The user can view the events in the Event Journal window that can be accessed from the Other info tab of the Subsidies management function.
Example of subsidy distribution according to the value of setup GRTPRV
For the investment project PL1, the assigned subsidy amount is 13,000 €.
Before FY 2005 closing, the subsidized expenses linked to PL1 are:
EXPENSES | ASSETS | ||||
Ref. | Ex-tax amount | Subsidy amount | Forcing index | Subsidy plan basis | Ref |
P1 | 10,000 | 2,000 | Inactive | 2,400 | BC1 |
P2 | 2,000 | 400 | Inactive | ||
P3 | 10,000 | 2,000 | Inactive | 2,600 | BC2 |
P4 | 3,000 | 600 | Inactive | ||
P5 | 10,000 | 2,000 | Inactive |
|
|
P6 | 30,000 | 6,000 | Inactive |
|
|
GRTPRVUPD set to No.
Case 1: the Review of earlier subsidies is prohibited (parameter GRTPRVUPD set to No).
After the FY 2005 closing, the situation will be the following:
EXPENSES | ASSETS | ||||
Ref. | Ex-tax amount | Subsidy amount | Forcing index | Subsidy plan basis | Ref |
P1 | 10,000 | 2,000 | Active | 2,400 | BC1 |
P2 | 2,000 | 400 | Active | ||
P3 | 10,000 | 2,000 | Active | 2,600 | BC2 |
P4 | 3,000 | 600 | Active | ||
P5 | 10,000 | 2,000 | Inactive |
|
|
P6 | 30,000 | 6,000 | Inactive |
|
|
In 2006:
- a new financial asset is created from the P5 expense of 10,000 €
- the assigned subsidy amount rises to 14,000 €
- a new expense P7 amounting to 1,500 € is recorded on PL1
The processing runs the following calculations:
- Calculation of the sum of the subsidies which are already assigned to expenditures and cannot be modified (expenditures whose forcing flag is active): 2,000 + 400 + 2,000 + 600 = 5,000
- Calculation of the subsidy remainder to distribute on expenditures and which can be modified (expenditures whose forcing flag is inactive): 14,000 – 5,000 = 9,000
- Calculation of the total of ex-tax expense amounts with an inactive forcing index:
10,000 + 30,000 + 1,500 = 41,500 - Calculation of the subsidy amount of the P5, P6 and P7 expenses:
P5: 9,000 X 10,000 / 41,500 = 2,168.67
P6: 9,000 X 30,000 / 41,500 = 6,506.02
P7: 9,000 X 1,500 / 41,500 = 325.31
Note: the subsidy calculation process does not modify the depreciation basis of the subsidy plan for both assets (FA1 and FA2) subject to the 2005 closing.
EXPENSES | ASSETS | ||||
Ref. | Ex-tax amount | Subsidy amount | Forcing index | Subsidy plan basis | Ref |
P1 | 10,000 | 2,000 | Active | 2,400 | BC1 |
P2 | 2,000 | 400 | Active | ||
P3 | 10,000 | 2,000 | Active | 2,600 | BC2 |
P4 | 3,000 | 600 | Active | ||
P5 | 10,000 | 2,168.67 | Inactive | 2,168.67 | BC3 |
P6 | 30,000 | 6,506.02 | Inactive |
|
|
P7 | 1,500 | 325.31 | Inactive |
|
|
Case 2: the Review of earlier subsidies is authorized (the GRTPRVUPD parameter is set to Yes).
After the FY 2005 closing, the situation will be the following:
EXPENSES | ASSETS | ||||
Ref. | Ex-tax amount | Subsidy amount | Forcing index | Subsidy plan basis | Ref |
P1 | 10,000 | 2,000 | Inactive | 2,400 | BC1 |
P2 | 2,000 | 400 | Inactive | ||
P3 | 10,000 | 2,000 | Inactive | 2,600 | BC2 |
P4 | 3,000 | 600 | Inactive | ||
P5 | 10,000 | 2,000 | Inactive |
|
|
P6 | 30,000 | 6,000 | Inactive |
|
|
In 2006:
- a new financial asset is created from the P5 expense of 10,000 €
- the assigned subsidy amount rises to 14,000 €
- a new expense P7 amounting to 1,500 € is recorded on PL1
The subsidy calculation process recalculates the subsidy amount for each expenditure whether it is linked or not to a closed asset; the depreciation basis of the subsidy plan is therefore actualized:
P1: 14,000 X 10,000 / 66,500 = 2,105.26
P2: 14,000 X 2,000 / 66,500 = 421.05
P3: 14,000 X 10,000 / 66,500 = 2,105.26
P4: 14,000 X 3,000 / 66,500 = 631.58
P5: 14,000 X 10,000 / 66,500 = 2,105.26
P6: 14,000 X 30,000 / 66,500 = 6,315.80
P7: 14,000 X 1,500 / 66,500 = 315.79
Note: the subsidy calculation process updates the depreciation basis of the subsidy plan for both assets (FA1 and FA2) subject to the 2005 closing.
EXPENSES | ASSETS | ||||
Ref. | Ex-tax amount | Subsidy amount | Forcing Code | Subsidy plan basis | Ref |
P1 | 10,000 | 2,105.26 | Inactive | 2,400 - 2,526.31 | BC1 |
P2 | 2,000 | 421.05 | Inactive | ||
P3 | 10,000 | 2,105.26 | Inactive | 2,600 -> 2,736.84 | BC2 |
P4 | 3,000 | 631.58 | Inactive | ||
P5 | 10,000 | 2,105.26 | Inactive | 2,105.26 | BC3 |
P6 | 30,000 | 6,315.80 | Inactive |
|
|
P7 | 1,500 | 315.79 | Inactive |
|
|